don't click here

Why cant I summit sonic R records?


    Print

Author Topic: Why cant I summit sonic R records?  (Read 20515 times)

0 Members and 2 Guests are viewing this topic.

Why cant I summit sonic R records?
« on: August 21, 2004, 12:39:43 pm »
For some strange reason I cant submit any of my times for sonic R
when I try to submit them it just says

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND e.creation='SUBMIT' GROUP BY e.class ORDER BY l.level_order

does anyone know what this means?  <_<

Offline Rolken

Why cant I summit sonic R records?
« Reply #1 on: August 21, 2004, 08:53:47 pm »
It works for me... do the other games work for you?
StH JJ1 WkS+ Sal++^i Rbk++i Knu- McS+++ P++ D[af]opw $++++ E03 A24 GM CoUT
What fun is it being cool if you can't wear a sombrero?

Why cant I summit sonic R records?
« Reply #2 on: August 22, 2004, 02:50:56 am »
yes they do

Why cant I summit sonic R records?
« Reply #3 on: August 30, 2004, 06:35:52 am »
sonic battle Submissions dont seem to work either it comes up with the same error as the sonic R Submissions  :(
Insert crappy text here

Offline sonicam

  • TSC's Most Easily Irritated Member
  • If I had a (ban)hammer
  • TSC Profile
  • win7 firefox
  • Posts: 666
    • View Profile
Why cant I summit sonic R records?
« Reply #4 on: August 30, 2004, 07:23:34 pm »
Quote
sonic battle Submissions dont seem to work either it comes up with the same error as the sonic R Submissions  :(
[snapback]4389[/snapback]

Sonic Battle submissions don't work for me either.
Chaos Emeralds: Yellow, Red, Green, Blue and Purple.
Keys: Light Blue.


Click here to level up my card!

Offline Bilan

  • Broseidon
  • TSC: RPGnutter
  • win10 chrome
  • Posts: 3883
  • ZURA ZURA CHUUPA CHUUPA CHUU CHUU
    • View Profile
    • I'm suffering help me Garian
Why cant I summit sonic R records?
« Reply #5 on: August 31, 2004, 05:50:23 pm »
Sonic R wont work for me either =(
Did you not think I had a mind?

Why cant I summit sonic R records?
« Reply #6 on: September 03, 2004, 01:48:58 pm »
oh yeah and sonic drift dont seem to work either  :(
Insert crappy text here

Offline SadisticMystic

Why cant I summit sonic R records?
« Reply #7 on: September 03, 2004, 03:05:48 pm »
I think I've got it.

What's the one thing Sonic R, Sonic Battle, and Sonic Drift all have in common?

The lack of a division 0.

Maybe the current code requires that the game have a division 0 in order to accept submissions.

Offline Bilan

  • Broseidon
  • TSC: RPGnutter
  • win10 chrome
  • Posts: 3883
  • ZURA ZURA CHUUPA CHUUPA CHUU CHUU
    • View Profile
    • I'm suffering help me Garian
Why cant I summit sonic R records?
« Reply #8 on: September 03, 2004, 04:12:01 pm »
...so you can fix that, right? *will probably find out now that its already been fixed*

EDIT: So....thats a no?
« Last Edit: September 05, 2004, 08:53:09 am by RPGnutter »
Did you not think I had a mind?

Offline Bilan

  • Broseidon
  • TSC: RPGnutter
  • win10 chrome
  • Posts: 3883
  • ZURA ZURA CHUUPA CHUUPA CHUU CHUU
    • View Profile
    • I'm suffering help me Garian
Why cant I summit sonic R records?
« Reply #9 on: September 07, 2004, 03:09:49 am »
I had a think about this and couldn't you solve this problem for Sonic Drift 1 & 2 and Sonic R by adding another division, even if noone submits for it.

You could use Rings for all of them, just see how many Rings you can finish the race with, although with Sonic R that'd have to be at the end of a 3 lap race.

I had a second idea for Sonic R for an extra division.

Make them into 'Grand Prix' and 'Time Attack'

Grand Prix mode is when you can collect Rings in the races, and you'd post fastest Lap times and Course Records.

Time Attack mode has no Rings, but it does have a mirrored track option, as well as Balloons and Tag.

I dunno if anyone else'll think thats a good idea but thats just my 2 cents.
« Last Edit: September 07, 2004, 10:47:16 am by RPGnutter »
Did you not think I had a mind?

Offline SadisticMystic

Why cant I summit sonic R records?
« Reply #10 on: September 07, 2004, 04:24:56 pm »
Rings wouldn't fix the problem since that's division 9, not 0.

Offline Bilan

  • Broseidon
  • TSC: RPGnutter
  • win10 chrome
  • Posts: 3883
  • ZURA ZURA CHUUPA CHUUPA CHUU CHUU
    • View Profile
    • I'm suffering help me Garian
Why cant I summit sonic R records?
« Reply #11 on: September 07, 2004, 04:26:34 pm »
Then whats Divison 0?..
Did you not think I had a mind?

Offline sonicam

  • TSC's Most Easily Irritated Member
  • If I had a (ban)hammer
  • TSC Profile
  • win7 firefox
  • Posts: 666
    • View Profile
Why cant I summit sonic R records?
« Reply #12 on: September 08, 2004, 06:54:51 pm »
I was thinking maybe a Time Division could be added for Sonic Battle but i don't know if that is Division 0, so what is this division?
Chaos Emeralds: Yellow, Red, Green, Blue and Purple.
Keys: Light Blue.


Click here to level up my card!

Offline Rolken

Why cant I summit sonic R records?
« Reply #13 on: September 09, 2004, 12:15:52 am »
Um... there shouldn't be ANY category 0s anymore. o.o; I upped them all by one... unless you mean what it really refers to as divisions.

sonicam, what levels/divs should be in a Sonic Battle time category? I don't know.
StH JJ1 WkS+ Sal++^i Rbk++i Knu- McS+++ P++ D[af]opw $++++ E03 A24 GM CoUT
What fun is it being cool if you can't wear a sombrero?

Offline sonicam

  • TSC's Most Easily Irritated Member
  • If I had a (ban)hammer
  • TSC Profile
  • win7 firefox
  • Posts: 666
    • View Profile
Why cant I summit sonic R records?
« Reply #14 on: September 09, 2004, 01:18:08 am »
Just the Battle Time. In Challenge Mode, after each Battle, you are given a results screen, and in the results screen there is a time record that tells you how long you took to finish the battle. I was thinking, you could divide the Time Division for each individual Character, with each of thier three Difficulty Levels and in each difficulty level, you would have each of the 5 battles. Here is an example since i know that was pretty confusing:

Character: Sonic: Total Time for Sonic's Level 1-3(it doesn't give you a time on the Challenge Mode character select, nor is there any place in the Records to be shown, this would just be calculated like all the other games calculate it's Time Attack records combined for a particular character)

Level 1: Total Time would be calculated here, like it is done with most Time Attack games(Total Time for Sonic's Level 1)(again, it isn't shown anywhere, it will just be a calculation of all the Battle Times for Level 1)

Battle 1: 1:02
Battle 2: 3:59
Battle 3: 1:08
Battle 4: 3:35
Battle 5: 2:30

These Times aren't shown anywhere, except after the battle is finished, you have to record the time somewhere in order to compete.

Level 2
Battle 1: 1:30
Battle 2: 1:38
Battle 3: 2:09
Battle 4: 4:09
Battle 5: 1:57

Level 3
Battle 1: 1:56
Battle 2: 2:40
Battle 3: 2:09
Battle 4: 2:02
Battle 5: 5:04

You'd do the same thing for all the other characters. This is maybe alot, but still, i'd be cool to compete for time in Sonic Battle.


Rolken, if that was overly confusing(i tend to make simple things more difficult), please tell me, and sorry in advance if it is.
Chaos Emeralds: Yellow, Red, Green, Blue and Purple.
Keys: Light Blue.


Click here to level up my card!

Offline Bilan

  • Broseidon
  • TSC: RPGnutter
  • win10 chrome
  • Posts: 3883
  • ZURA ZURA CHUUPA CHUUPA CHUU CHUU
    • View Profile
    • I'm suffering help me Garian
Why cant I summit sonic R records?
« Reply #15 on: September 10, 2004, 05:16:57 pm »
Meh...Sonic Jam doesn't work either
Did you not think I had a mind?

Offline Rolken

Why cant I summit sonic R records?
« Reply #16 on: September 15, 2004, 12:29:39 am »
OK, I finally tracked down and fixed this problem. It had to do with the HTML and PHP not passing data to each other that they should've. Sorry, guys. :P
StH JJ1 WkS+ Sal++^i Rbk++i Knu- McS+++ P++ D[af]opw $++++ E03 A24 GM CoUT
What fun is it being cool if you can't wear a sombrero?

Offline Bilan

  • Broseidon
  • TSC: RPGnutter
  • win10 chrome
  • Posts: 3883
  • ZURA ZURA CHUUPA CHUUPA CHUU CHUU
    • View Profile
    • I'm suffering help me Garian
Why cant I summit sonic R records?
« Reply #17 on: September 15, 2004, 03:01:47 am »
YAY! Thanks Rolko! =)
Did you not think I had a mind?

Offline sonicam

  • TSC's Most Easily Irritated Member
  • If I had a (ban)hammer
  • TSC Profile
  • win7 firefox
  • Posts: 666
    • View Profile
Why cant I summit sonic R records?
« Reply #18 on: September 16, 2004, 12:28:05 am »
Thanx Rolken!

Also, what do you think of the Time Division idea for Sonic Battle, Rolken?

« Last Edit: September 16, 2004, 12:30:08 am by sonicam »
Chaos Emeralds: Yellow, Red, Green, Blue and Purple.
Keys: Light Blue.


Click here to level up my card!

    Print
 


-- Back to Normal Skin --
Hits: 42 | Hits This Month: 3 | DB Calls: 5 | Mem Usage: 1.17 MB | Time: 0.07s | Printable

The Sonic Center v3.9
Copyright 2003-2011 by The Sonic Center Team.